Correcting string data
Reading aggregated Data
Transforming Catagorical data
1. Which SHIP MODE is most consumed while order is placed in the store. Visualized consumsion of each SHIP MODE through Bar Chart.
2. When a customer place an order what is the probablity that he consume "First class" as SHIP MODE. Show Probablity of Each Mode in Generalized manner Of SHIP MODE.
3. After Getting the Visuals of SHIP MODE, Identify the SHIP MODE consumptionby each SEGMENT..
4. Find corelation between segment and shipping mode. Generalize Coorelation on whole data.
5.What is the probablity when it is a "standard class" SHIP MODE the SEGMENT is "home office". Generalize Probablity of SEGMENT for each SHIP MODE.
6. Plot Discount availed by Each City
7. Plot Sales Performed by Each City
8. What is the probablity that City 'New York City' consumed 'standard class' SHIP MODE? Generalized Probablity for each SHIP MODE.
9. Show CATEGORY and SUB-CATEGORY visualization based on all PRODUCT sales
10. If the CATEGORY is 'Office supply' then what will be the provbablity the SUB-CATEGORY is 'Binder'? Generalized for each SUB-CATEGORY
11. Which CATEGORYY performs highest sales and also plot for each month
12. On bases of best selling month plot the graph of SUB-CATEGORY of above generated graph shows 'Technology' is most sold CATEGORY , which generate highest sales.
13. On bases of best selling MONTH plot the graph of STATES which generate highest SALES.
14. Which CATEGORY performs highest PROFIT and also plot for each MONTH.
15. On bases of best PROFIT MONTH plot the graph of SUB_CATEGORY of above generated graph shows 'Technology' is most Profitable CATEGORY and shows in the MONTH of 'March', which generate highest SALES.
16. Show relation of each category with each other using graphical visualization, which interprates consumption togather.
17. What is the probablity that if the CATEGORY is 'furniture' the SEGMENT will be 'homeOffice'? Generalized for all SEGMENT with respect to CATEGORY.
18. What is the probablity that if the category is 'Technology' the city is 'Los Angeles'? Generalized for all REGION with respect to CATEGORY.
19. What is the probablity of each CATEGORY of all the STATES in West REGION
20. What is the probablity of each CATEGORY of all the CITIES in STATE.
21. What CATEGORY offers highest DISCOUNT, does it effect the SALES
1. what are the most frequent categories combination in each 'purchase order' or
what can be the possible combination in most used categories in each 'Order'?